Datenbänke

Diese Information ist nur relevant wenn Sie eine Lizenz Fisa Logger besitzen. Siehe Fisa Logger

Datenbänke
   Logger Master.cmb
   Logger.cmb
Struktur
How Data are Created and Saved
Abfragen
Beispiel Abfrage



Datenbänke

Fisa Logger databases have the extension *.cmb. Dateiextensionen

These databases are only used for saving Production data with Fisa Logger License.

Die Datenbänke können mit Access 2000(in Microsoft Office 2000 Professional or later)geöffnet werden. By default, the databases are password protected. Sie können das Kennwort ändern oder entfernen. Wie das Kennwort geändert wird

Fisa Logger arbeitet mit zwei Datenbänken:

  • Logger Master.cmb
  • Logger.cmb

    Logger Master serves as the template for creating a new Installation.cmb (working database). Logger.cmb will be named as your Installation name, eg My First Installation.cmb. The structure of the Logger.cmb will therefore be the same as for Logger Master.cmb, except for the table Operators which exists only in the Logger Master.cmb.


    Logger Master.cmb

    Located in the application path

    Sie müssen das Kennwort für Logger Master.cmb kennen, um in Administratorebene hereinzukommen. Administratorebene


    Logger.cmb

    Located in the same path as the *.cmg file.
    Normalerweise \Fisa Software\Fisa Project\Installations\MyFirst Installation.cmb.
    Dateiextensionen

    This database is created as a copy of Logger Master.cmb whenever creating a new installation. The Logger.cmb could also be created if it is not found at the same location as the *.cmg file.

    The Logger.cmb can have a different password than the one in Logger Master.cmb.


    Struktur




    How Data are Created and Saved




    Abfragen

    The most important queries for data mining in the Logger database are already included in Fisa Logger. Der Korbanalysator

    This does not exclude that you might want to prepare your own, more refined, queries based on the stucture described above.


    Beispiel Abfrage

    A query like this one is easily constructed in the Access 2000 Query design interface:

    The produced SQL string looks like this:

    SELECT Baskets.*, Baskets.Barcode FROM ((Operators INNER JOIN [Session] ON Operators.Operator = Session.Operator) INNER JOIN Baskets ON Session.Counter = Baskets.SessionID) INNER JOIN Visits ON Baskets.Counter = Visits.BasketsID WHERE (((Baskets.Barcode) Like "????###AB*"));